Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
SID | NUMBER(38) | No | null | 1 | null | NO | NO | NO |
PARTIC_OBJ | VARCHAR2(20) | Yes | null | 2 | null | NO | NO | NO |
PARTICIPANT_DISPLAY | VARCHAR2(20) | Yes | null | 3 | null | NO | NO | NO |
OUTCOME | VARCHAR2(4000) | Yes | null | 4 | null | NO | NO | NO |
OUTCOME_SUBCATEGORY | VARCHAR2(4000) | Yes | null | 5 | null | NO | NO | NO |
OFFICE | VARCHAR2(4000) | Yes | null | 6 | null | NO | NO | NO |
START_DATE | DATE | Yes | null | 7 | null | NO | NO | NO |
END_DATE | DATE | Yes | null | 8 | null | NO | NO | NO |
EMPLOYEE_TYPE | VARCHAR2(4000) | Yes | null | 9 | null | NO | NO | NO |
ID | VARCHAR2(100) | Yes | null | 10 | null | NO | NO | NO |
TITLE | VARCHAR2(400) | Yes | null | 11 | null | NO | NO | NO |
CREATED_ON | DATE | Yes | null | 12 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 13 | null | NO | NO | NO |
INTERCOM_LEAD | VARCHAR2(400) | Yes | null | 14 | null | NO | NO | NO |
OWNING_UNIT | VARCHAR2(400) | Yes | null | 15 | null | NO | NO | NO |
CREATE_UNIT | VARCHAR2(400) | Yes | null | 16 | null | NO | NO | NO |
RCV_UNIT | VARCHAR2(400) | Yes | null | 17 | null | NO | NO | NO |
REFERRAL_TYPE | VARCHAR2(100) | No | null | 18 | null | NO | NO | NO |
NEXT_DUE_DATE | DATE | Yes | null | 19 | null | NO | NO | NO |
FINAL_DUE_DATE | DATE | Yes | null | 20 | null | NO | NO | NO |
LAST_MODIFIED_DATE | DATE | Yes | null | 21 | null | NO | NO | NO |
SOURCE | VARCHAR2(4000) | Yes | null | 22 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
References
NAME | VALUE |
---|---|
CREATED | 17-MAY-23 |
LAST_DDL_TIME | 05-FEB-25 |
OWNER | QART |
VIEW_NAME | V_CUBE_PARTIC_OUTCOMES_INTERCOMS |
TEXT_LENGTH | 752 |
TEXT | SELECT DISTINCT O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD AS INTERCOM_LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE FROM V_CUBE_INDIV_PARTIC_OUTCOMES O, V_CUBE_INTERCOM_ALL I GROUP BY (O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE) |
TEXT_VC | SELECT DISTINCT O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD AS INTERCOM_LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE FROM V_CUBE_INDIV_PARTIC_OUTCOMES O, V_CUBE_INTERCOM_ALL I GROUP BY (O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE) |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|